Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 5840 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 456.4 KiB |
| Average record size in memory | 80.0 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 8 |
| Categorical | 4 |
engine is highly overall correlated with max_power and 2 other fields | High correlation |
km_driven is highly overall correlated with year | High correlation |
max_power is highly overall correlated with engine and 2 other fields | High correlation |
nm is highly overall correlated with engine and 2 other fields | High correlation |
rpm is highly overall correlated with nm | High correlation |
seats is highly overall correlated with engine | High correlation |
transmission is highly overall correlated with max_power | High correlation |
year is highly overall correlated with km_driven | High correlation |
seller_type is highly imbalanced (67.7%) | Imbalance |
transmission is highly imbalanced (57.6%) | Imbalance |
Reproduction
| Analysis started | 2024-11-27 20:42:52.480259 |
|---|---|
| Analysis finished | 2024-11-27 20:43:34.800879 |
| Duration | 42.32 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
name
Text
| Distinct | 1924 |
|---|---|
| Distinct (%) | 32.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.8 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 42 |
| Mean length | 25.221918 |
| Min length | 11 |
Unique
| Unique | 912 ? |
|---|---|
| Unique (%) | 15.6% |
Sample
| 1st row | Maruti Swift Dzire VDI |
|---|---|
| 2nd row | Skoda Rapid 1.5 TDI Ambition |
| 3rd row | Hyundai i20 Sportz Diesel |
| 4th row | Maruti Swift VXI BSIII |
| 5th row | Hyundai Xcent 1.2 VTVT E Plus |
| Value | Count | Frequency (%) |
| maruti | 1804 | 6.5% |
| hyundai | 1058 | 3.8% |
| mahindra | 611 | 2.2% |
| swift | 558 | 2.0% |
| tata | 534 | 1.9% |
| bsiv | 494 | 1.8% |
| diesel | 460 | 1.7% |
| 1.2 | 423 | 1.5% |
| vxi | 409 | 1.5% |
| plus | 401 | 1.5% |
| Other values (828) | 20886 |
Most occurring characters
| Value | Count | Frequency (%) |
| 21799 | 14.8% | |
| a | 10756 | 7.3% |
| i | 9826 | 6.7% |
| t | 7431 | 5.0% |
| r | 6474 | 4.4% |
| o | 5841 | 4.0% |
| n | 5635 | 3.8% |
| e | 5425 | 3.7% |
| u | 4335 | 2.9% |
| S | 3981 | 2.7% |
| Other values (58) | 65793 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 147296 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 21799 | 14.8% | |
| a | 10756 | 7.3% |
| i | 9826 | 6.7% |
| t | 7431 | 5.0% |
| r | 6474 | 4.4% |
| o | 5841 | 4.0% |
| n | 5635 | 3.8% |
| e | 5425 | 3.7% |
| u | 4335 | 2.9% |
| S | 3981 | 2.7% |
| Other values (58) | 65793 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 147296 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 21799 | 14.8% | |
| a | 10756 | 7.3% |
| i | 9826 | 6.7% |
| t | 7431 | 5.0% |
| r | 6474 | 4.4% |
| o | 5841 | 4.0% |
| n | 5635 | 3.8% |
| e | 5425 | 3.7% |
| u | 4335 | 2.9% |
| S | 3981 | 2.7% |
| Other values (58) | 65793 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 147296 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 21799 | 14.8% | |
| a | 10756 | 7.3% |
| i | 9826 | 6.7% |
| t | 7431 | 5.0% |
| r | 6474 | 4.4% |
| o | 5841 | 4.0% |
| n | 5635 | 3.8% |
| e | 5425 | 3.7% |
| u | 4335 | 2.9% |
| S | 3981 | 2.7% |
| Other values (58) | 65793 |
year
Real number (ℝ)
High correlation
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.4284 |
| Minimum | 1983 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 1983 |
|---|---|
| 5-th percentile | 2006 |
| Q1 | 2011 |
| median | 2014 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 37 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.0956221 |
|---|---|
| Coefficient of variation (CV) | 0.0020341533 |
| Kurtosis | 1.6930209 |
| Mean | 2013.4284 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.0195011 |
| Sum | 11758422 |
| Variance | 16.774118 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 2017 | 666 | |
| 2016 | 596 | |
| 2015 | 568 | |
| 2018 | 522 | |
| 2012 | 507 | |
| 2014 | 480 | |
| 2013 | 478 | |
| 2011 | 461 | |
| 2010 | 322 | 5.5% |
| 2019 | 298 | 5.1% |
| Other values (19) | 942 |
| Value | Count | Frequency (%) |
| 1983 | 1 | < 0.1% |
| 1991 | 1 | < 0.1% |
| 1994 | 3 | 0.1% |
| 1995 | 1 | < 0.1% |
| 1996 | 3 | 0.1% |
| 1997 | 10 | |
| 1998 | 9 | |
| 1999 | 12 | |
| 2000 | 19 | |
| 2001 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 2020 | 58 | 1.0% |
| 2019 | 298 | |
| 2018 | 522 | |
| 2017 | 666 | |
| 2016 | 596 | |
| 2015 | 568 | |
| 2014 | 480 | |
| 2013 | 478 | |
| 2012 | 507 | |
| 2011 | 461 |
km_driven
Real number (ℝ)
High correlation
| Distinct | 827 |
|---|---|
| Distinct (%) | 14.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73952.242 |
| Minimum | 1 |
|---|---|
| Maximum | 2360457 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 11000 |
| Q1 | 39000 |
| median | 70000 |
| Q3 | 100000 |
| 95-th percentile | 156041 |
| Maximum | 2360457 |
| Range | 2360456 |
| Interquartile range (IQR) | 61000 |
Descriptive statistics
| Standard deviation | 60071.137 |
|---|---|
| Coefficient of variation (CV) | 0.81229635 |
| Kurtosis | 416.02466 |
| Mean | 73952.242 |
| Median Absolute Deviation (MAD) | 30000 |
| Skewness | 12.645506 |
| Sum | 4.318811 × 108 |
| Variance | 3.6085414 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 120000 | 429 | 7.3% |
| 80000 | 356 | 6.1% |
| 70000 | 350 | 6.0% |
| 60000 | 327 | 5.6% |
| 50000 | 305 | 5.2% |
| 100000 | 279 | 4.8% |
| 90000 | 262 | 4.5% |
| 40000 | 227 | 3.9% |
| 110000 | 225 | 3.9% |
| 30000 | 184 | 3.2% |
| Other values (817) | 2896 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 1000 | 5 | |
| 1300 | 1 | < 0.1% |
| 1303 | 1 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 1600 | 1 | < 0.1% |
| 1620 | 1 | < 0.1% |
| 2000 | 6 | |
| 2118 | 1 | < 0.1% |
| 2136 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2360457 | 1 | |
| 1500000 | 1 | |
| 577414 | 1 | |
| 500000 | 2 | |
| 475000 | 1 | |
| 440000 | 1 | |
| 426000 | 1 | |
| 380000 | 1 | |
| 376412 | 1 | |
| 370000 | 1 |
fuel
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.8 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 50 |
| LPG | 34 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.9568493 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Diesel |
|---|---|
| 2nd row | Diesel |
| 3rd row | Diesel |
| 4th row | Petrol |
| 5th row | Petrol |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3177 | |
| Petrol | 2579 | |
| CNG | 50 | 0.9% |
| LPG | 34 | 0.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3177 | |
| petrol | 2579 | |
| cng | 50 | 0.9% |
| lpg | 34 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8933 | |
| l | 5756 | |
| D | 3177 | 9.1% |
| i | 3177 | 9.1% |
| s | 3177 | 9.1% |
| P | 2613 | 7.5% |
| t | 2579 | 7.4% |
| r | 2579 | 7.4% |
| o | 2579 | 7.4% |
| G | 84 | 0.2% |
| Other values (3) | 134 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34788 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 8933 | |
| l | 5756 | |
| D | 3177 | 9.1% |
| i | 3177 | 9.1% |
| s | 3177 | 9.1% |
| P | 2613 | 7.5% |
| t | 2579 | 7.4% |
| r | 2579 | 7.4% |
| o | 2579 | 7.4% |
| G | 84 | 0.2% |
| Other values (3) | 134 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34788 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 8933 | |
| l | 5756 | |
| D | 3177 | 9.1% |
| i | 3177 | 9.1% |
| s | 3177 | 9.1% |
| P | 2613 | 7.5% |
| t | 2579 | 7.4% |
| r | 2579 | 7.4% |
| o | 2579 | 7.4% |
| G | 84 | 0.2% |
| Other values (3) | 134 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34788 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 8933 | |
| l | 5756 | |
| D | 3177 | 9.1% |
| i | 3177 | 9.1% |
| s | 3177 | 9.1% |
| P | 2613 | 7.5% |
| t | 2579 | 7.4% |
| r | 2579 | 7.4% |
| o | 2579 | 7.4% |
| G | 84 | 0.2% |
| Other values (3) | 134 | 0.4% |
seller_type
Categorical
Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.8 KiB |
| Individual | |
|---|---|
| Dealer | |
| Trustmark Dealer | 25 |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.6202055 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Individual |
|---|---|
| 2nd row | Individual |
| 3rd row | Individual |
| 4th row | Individual |
| 5th row | Individual |
Common Values
| Value | Count | Frequency (%) |
| Individual | 5223 | |
| Dealer | 592 | 10.1% |
| Trustmark Dealer | 25 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| individual | 5223 | |
| dealer | 617 | 10.5% |
| trustmark | 25 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 10446 | |
| i | 10446 | |
| a | 5865 | |
| l | 5840 | |
| u | 5248 | |
| I | 5223 | |
| v | 5223 | |
| n | 5223 | |
| e | 1234 | 2.2% |
| r | 667 | 1.2% |
| Other values (7) | 767 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 56182 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| d | 10446 | |
| i | 10446 | |
| a | 5865 | |
| l | 5840 | |
| u | 5248 | |
| I | 5223 | |
| v | 5223 | |
| n | 5223 | |
| e | 1234 | 2.2% |
| r | 667 | 1.2% |
| Other values (7) | 767 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 56182 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| d | 10446 | |
| i | 10446 | |
| a | 5865 | |
| l | 5840 | |
| u | 5248 | |
| I | 5223 | |
| v | 5223 | |
| n | 5223 | |
| e | 1234 | 2.2% |
| r | 667 | 1.2% |
| Other values (7) | 767 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 56182 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| d | 10446 | |
| i | 10446 | |
| a | 5865 | |
| l | 5840 | |
| u | 5248 | |
| I | 5223 | |
| v | 5223 | |
| n | 5223 | |
| e | 1234 | 2.2% |
| r | 667 | 1.2% |
| Other values (7) | 767 | 1.4% |
transmission
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.8 KiB |
| Manual | |
|---|---|
| Automatic | 504 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.2589041 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Manual |
Common Values
| Value | Count | Frequency (%) |
| Manual | 5336 | |
| Automatic | 504 | 8.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 5336 | |
| automatic | 504 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 11176 | |
| u | 5840 | |
| M | 5336 | |
| n | 5336 | |
| l | 5336 | |
| t | 1008 | 2.8% |
| A | 504 | 1.4% |
| o | 504 | 1.4% |
| m | 504 | 1.4% |
| i | 504 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 36552 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 11176 | |
| u | 5840 | |
| M | 5336 | |
| n | 5336 | |
| l | 5336 | |
| t | 1008 | 2.8% |
| A | 504 | 1.4% |
| o | 504 | 1.4% |
| m | 504 | 1.4% |
| i | 504 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 36552 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 11176 | |
| u | 5840 | |
| M | 5336 | |
| n | 5336 | |
| l | 5336 | |
| t | 1008 | 2.8% |
| A | 504 | 1.4% |
| o | 504 | 1.4% |
| m | 504 | 1.4% |
| i | 504 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 36552 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 11176 | |
| u | 5840 | |
| M | 5336 | |
| n | 5336 | |
| l | 5336 | |
| t | 1008 | 2.8% |
| A | 504 | 1.4% |
| o | 504 | 1.4% |
| m | 504 | 1.4% |
| i | 504 | 1.4% |
owner
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.8 KiB |
| First Owner | |
|---|---|
| Second Owner | |
| Third Owner | |
| Fourth & Above Owner | 140 |
| Test Drive Car | 4 |
Length
| Max length | 20 |
|---|---|
| Median length | 11 |
| Mean length | 11.498459 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First Owner |
|---|---|
| 2nd row | Second Owner |
| 3rd row | First Owner |
| 4th row | First Owner |
| 5th row | First Owner |
Common Values
| Value | Count | Frequency (%) |
| First Owner | 3603 | |
| Second Owner | 1639 | |
| Third Owner | 454 | 7.8% |
| Fourth & Above Owner | 140 | 2.4% |
| Test Drive Car | 4 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| owner | 5836 | |
| first | 3603 | |
| second | 1639 | 13.7% |
| third | 454 | 3.8% |
| fourth | 140 | 1.2% |
| 140 | 1.2% | |
| above | 140 | 1.2% |
| test | 4 | < 0.1% |
| drive | 4 | < 0.1% |
| car | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 10041 | |
| e | 7623 | |
| n | 7475 | |
| 6124 | ||
| O | 5836 | |
| w | 5836 | |
| i | 4061 | |
| t | 3747 | 5.6% |
| F | 3743 | 5.6% |
| s | 3607 | 5.4% |
| Other values (14) | 9058 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 67151 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 10041 | |
| e | 7623 | |
| n | 7475 | |
| 6124 | ||
| O | 5836 | |
| w | 5836 | |
| i | 4061 | |
| t | 3747 | 5.6% |
| F | 3743 | 5.6% |
| s | 3607 | 5.4% |
| Other values (14) | 9058 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 67151 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 10041 | |
| e | 7623 | |
| n | 7475 | |
| 6124 | ||
| O | 5836 | |
| w | 5836 | |
| i | 4061 | |
| t | 3747 | 5.6% |
| F | 3743 | 5.6% |
| s | 3607 | 5.4% |
| Other values (14) | 9058 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 67151 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 10041 | |
| e | 7623 | |
| n | 7475 | |
| 6124 | ||
| O | 5836 | |
| w | 5836 | |
| i | 4061 | |
| t | 3747 | 5.6% |
| F | 3743 | 5.6% |
| s | 3607 | 5.4% |
| Other values (14) | 9058 |
mileage
Real number (ℝ)
| Distinct | 375 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.428611 |
| Minimum | 0 |
|---|---|
| Maximum | 42 |
| Zeros | 14 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12.8285 |
| Q1 | 16.950001 |
| median | 19.299999 |
| Q3 | 22.299999 |
| 95-th percentile | 25.799999 |
| Maximum | 42 |
| Range | 42 |
| Interquartile range (IQR) | 5.3499985 |
Descriptive statistics
| Standard deviation | 3.986026 |
|---|---|
| Coefficient of variation (CV) | 0.20516268 |
| Kurtosis | 0.87149566 |
| Mean | 19.428611 |
| Median Absolute Deviation (MAD) | 2.6999989 |
| Skewness | -0.17337286 |
| Sum | 113463.09 |
| Variance | 15.888404 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19.29999924 | 240 | 4.1% |
| 18.89999962 | 175 | 3.0% |
| 19.70000076 | 137 | 2.3% |
| 18.60000038 | 126 | 2.2% |
| 21.10000038 | 118 | 2.0% |
| 17 | 105 | 1.8% |
| 15.96000004 | 95 | 1.6% |
| 17.79999924 | 90 | 1.5% |
| 16.10000038 | 84 | 1.4% |
| 15.10000038 | 76 | 1.3% |
| Other values (365) | 4594 |
| Value | Count | Frequency (%) |
| 0 | 14 | |
| 9 | 4 | 0.1% |
| 9.5 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 10.10000038 | 2 | < 0.1% |
| 10.5 | 14 | |
| 10.71000004 | 1 | < 0.1% |
| 10.75 | 1 | < 0.1% |
| 10.80000019 | 1 | < 0.1% |
| 10.89999962 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 42 | 1 | < 0.1% |
| 33.43999863 | 2 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32.52000046 | 1 | < 0.1% |
| 30.45999908 | 2 | < 0.1% |
| 28.39999962 | 70 | |
| 28.09000015 | 29 | |
| 27.62000084 | 5 | 0.1% |
| 27.39999962 | 4 | 0.1% |
| 27.38999939 | 20 | 0.3% |
engine
Real number (ℝ)
High correlation
| Distinct | 120 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1429.449 |
| Minimum | 624 |
|---|---|
| Maximum | 3604 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.8 KiB |
Quantile statistics
| Minimum | 624 |
|---|---|
| 5-th percentile | 796 |
| Q1 | 1197 |
| median | 1248 |
| Q3 | 1498 |
| 95-th percentile | 2499 |
| Maximum | 3604 |
| Range | 2980 |
| Interquartile range (IQR) | 301 |
Descriptive statistics
| Standard deviation | 485.66283 |
|---|---|
| Coefficient of variation (CV) | 0.33975528 |
| Kurtosis | 1.1206263 |
| Mean | 1429.449 |
| Median Absolute Deviation (MAD) | 213 |
| Skewness | 1.2669542 |
| Sum | 8347982 |
| Variance | 235868.39 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1248 | 944 | 16.2% |
| 1197 | 589 | 10.1% |
| 796 | 338 | 5.8% |
| 998 | 335 | 5.7% |
| 2179 | 283 | 4.8% |
| 1498 | 283 | 4.8% |
| 1396 | 230 | 3.9% |
| 1199 | 163 | 2.8% |
| 2523 | 156 | 2.7% |
| 1461 | 146 | 2.5% |
| Other values (110) | 2373 |
| Value | Count | Frequency (%) |
| 624 | 15 | 0.3% |
| 793 | 5 | 0.1% |
| 796 | 338 | |
| 799 | 56 | 1.0% |
| 814 | 87 | 1.5% |
| 909 | 2 | < 0.1% |
| 936 | 27 | 0.5% |
| 993 | 24 | 0.4% |
| 995 | 39 | 0.7% |
| 998 | 335 |
| Value | Count | Frequency (%) |
| 3604 | 1 | < 0.1% |
| 3498 | 1 | < 0.1% |
| 3198 | 2 | < 0.1% |
| 2999 | 2 | < 0.1% |
| 2997 | 2 | < 0.1% |
| 2993 | 12 | |
| 2987 | 8 | 0.1% |
| 2982 | 23 | |
| 2967 | 8 | 0.1% |
| 2956 | 14 |
max_power
Real number (ℝ)
High correlation
| Distinct | 313 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.910782 |
| Minimum | 0 |
|---|---|
| Maximum | 400 |
| Zeros | 3 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 47.299999 |
| Q1 | 68 |
| median | 81.860001 |
| Q3 | 99 |
| 95-th percentile | 147.89999 |
| Maximum | 400 |
| Range | 400 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 31.639585 |
|---|---|
| Coefficient of variation (CV) | 0.35990563 |
| Kurtosis | 6.0466399 |
| Mean | 87.910782 |
| Median Absolute Deviation (MAD) | 14.809998 |
| Skewness | 1.7994332 |
| Sum | 513398.97 |
| Variance | 1001.0634 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 82 | 271 | 4.6% |
| 74 | 260 | 4.5% |
| 88.5 | 163 | 2.8% |
| 67 | 130 | 2.2% |
| 46.29999924 | 127 | 2.2% |
| 67.09999847 | 117 | 2.0% |
| 62.09999847 | 116 | 2.0% |
| 67.04000092 | 115 | 2.0% |
| 81.80000305 | 115 | 2.0% |
| 70 | 110 | 1.9% |
| Other values (303) | 4316 |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.1% |
| 32.79999924 | 2 | < 0.1% |
| 34.20000076 | 17 | 0.3% |
| 35 | 14 | 0.2% |
| 35.5 | 2 | < 0.1% |
| 37 | 69 | |
| 37.47999954 | 7 | 0.1% |
| 37.5 | 6 | 0.1% |
| 38 | 1 | < 0.1% |
| 38.40000153 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 400 | 1 | < 0.1% |
| 282 | 1 | < 0.1% |
| 280 | 1 | < 0.1% |
| 272 | 1 | < 0.1% |
| 270.8999939 | 3 | |
| 265 | 1 | < 0.1% |
| 261.3999939 | 4 | |
| 258 | 2 | |
| 254.8000031 | 3 | |
| 254.7899933 | 1 | < 0.1% |
seats
Real number (ℝ)
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4267123 |
| Minimum | 2 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.8 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 14 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.98234395 |
|---|---|
| Coefficient of variation (CV) | 0.18102009 |
| Kurtosis | 4.0793845 |
| Mean | 5.4267123 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0098753 |
| Sum | 31692 |
| Variance | 0.96499964 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 5 | 4618 | |
| 7 | 800 | 13.7% |
| 8 | 191 | 3.3% |
| 4 | 94 | 1.6% |
| 9 | 68 | 1.2% |
| 6 | 48 | 0.8% |
| 10 | 18 | 0.3% |
| 2 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 2 | < 0.1% |
| 4 | 94 | 1.6% |
| 5 | 4618 | |
| 6 | 48 | 0.8% |
| 7 | 800 | 13.7% |
| 8 | 191 | 3.3% |
| 9 | 68 | 1.2% |
| 10 | 18 | 0.3% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 10 | 18 | 0.3% |
| 9 | 68 | 1.2% |
| 8 | 191 | 3.3% |
| 7 | 800 | 13.7% |
| 6 | 48 | 0.8% |
| 5 | 4618 | |
| 4 | 94 | 1.6% |
| 2 | 2 | < 0.1% |
nm
Real number (ℝ)
High correlation
| Distinct | 181 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.38966 |
| Minimum | 51 |
|---|---|
| Maximum | 789 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 51 |
|---|---|
| 5-th percentile | 69 |
| Q1 | 113 |
| median | 171 |
| Q3 | 200 |
| 95-th percentile | 330 |
| Maximum | 789 |
| Range | 738 |
| Interquartile range (IQR) | 87 |
Descriptive statistics
| Standard deviation | 82.179443 |
|---|---|
| Coefficient of variation (CV) | 0.47670751 |
| Kurtosis | 4.4586191 |
| Mean | 172.38966 |
| Median Absolute Deviation (MAD) | 56.269997 |
| Skewness | 1.4811313 |
| Sum | 1006755.6 |
| Variance | 6753.4604 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 171 | 622 | 10.7% |
| 200 | 503 | 8.6% |
| 190 | 454 | 7.8% |
| 90 | 297 | 5.1% |
| 114 | 191 | 3.3% |
| 113 | 148 | 2.5% |
| 160 | 139 | 2.4% |
| 62 | 130 | 2.2% |
| 250 | 109 | 1.9% |
| 330 | 101 | 1.7% |
| Other values (171) | 3146 |
| Value | Count | Frequency (%) |
| 51 | 13 | 0.2% |
| 57 | 2 | < 0.1% |
| 59 | 85 | |
| 60 | 2 | < 0.1% |
| 62 | 130 | |
| 69 | 101 | |
| 71 | 3 | 0.1% |
| 72 | 56 | |
| 72.90000153 | 1 | < 0.1% |
| 74.5 | 87 |
| Value | Count | Frequency (%) |
| 789 | 3 | |
| 640 | 1 | < 0.1% |
| 620 | 6 | |
| 619 | 3 | |
| 600 | 3 | |
| 580 | 2 | < 0.1% |
| 560 | 2 | < 0.1% |
| 550 | 6 | |
| 540 | 1 | < 0.1% |
| 510 | 1 | < 0.1% |
rpm
Real number (ℝ)
High correlation
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3022.2274 |
| Minimum | 0 |
|---|---|
| Maximum | 5300 |
| Zeros | 23 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1750 |
| Q1 | 2400 |
| median | 3000 |
| Q3 | 3750 |
| 95-th percentile | 4500 |
| Maximum | 5300 |
| Range | 5300 |
| Interquartile range (IQR) | 1350 |
Descriptive statistics
| Standard deviation | 883.703 |
|---|---|
| Coefficient of variation (CV) | 0.29240123 |
| Kurtosis | -0.47445929 |
| Mean | 3022.2274 |
| Median Absolute Deviation (MAD) | 600 |
| Skewness | 0.025050312 |
| Sum | 17649808 |
| Variance | 780931 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 3000 | 990 | |
| 4000 | 707 | |
| 2000 | 621 | |
| 3500 | 547 | |
| 1750 | 430 | 7.4% |
| 2500 | 398 | 6.8% |
| 2750 | 328 | 5.6% |
| 2800 | 310 | 5.3% |
| 4200 | 183 | 3.1% |
| 4500 | 162 | 2.8% |
| Other values (37) | 1164 |
| Value | Count | Frequency (%) |
| 0 | 23 | 0.4% |
| 500 | 12 | 0.2% |
| 1400 | 2 | < 0.1% |
| 1500 | 64 | 1.1% |
| 1600 | 1 | < 0.1% |
| 1740 | 1 | < 0.1% |
| 1750 | 430 | |
| 1800 | 29 | 0.5% |
| 1850 | 1 | < 0.1% |
| 1900 | 30 | 0.5% |
| Value | Count | Frequency (%) |
| 5300 | 1 | < 0.1% |
| 5200 | 1 | < 0.1% |
| 5000 | 22 | 0.4% |
| 4850 | 18 | 0.3% |
| 4800 | 72 | |
| 4750 | 7 | 0.1% |
| 4700 | 7 | 0.1% |
| 4600 | 50 | 0.9% |
| 4500 | 162 | |
| 4400 | 55 | 0.9% |
Interactions
Correlations
| engine | fuel | km_driven | max_power | mileage | nm | owner | rpm | seats | seller_type | transmission | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| engine | 1.000 | 0.445 | 0.305 | 0.714 | -0.430 | 0.815 | 0.078 | -0.363 | 0.528 | 0.096 | 0.400 | -0.038 |
| fuel | 0.445 | 1.000 | 0.038 | 0.153 | 0.293 | 0.467 | 0.025 | 0.454 | 0.214 | 0.048 | 0.036 | 0.133 |
| km_driven | 0.305 | 0.038 | 1.000 | 0.043 | -0.198 | 0.238 | 0.033 | -0.312 | 0.195 | 0.000 | 0.016 | -0.570 |
| max_power | 0.714 | 0.153 | 0.043 | 1.000 | -0.308 | 0.743 | 0.070 | -0.053 | 0.305 | 0.155 | 0.513 | 0.162 |
| mileage | -0.430 | 0.293 | -0.198 | -0.308 | 1.000 | -0.145 | 0.094 | -0.173 | -0.435 | 0.040 | 0.244 | 0.347 |
| nm | 0.815 | 0.467 | 0.238 | 0.743 | -0.145 | 1.000 | 0.090 | -0.565 | 0.428 | 0.135 | 0.455 | 0.107 |
| owner | 0.078 | 0.025 | 0.033 | 0.070 | 0.094 | 0.090 | 1.000 | 0.096 | 0.016 | 0.134 | 0.119 | 0.257 |
| rpm | -0.363 | 0.454 | -0.312 | -0.053 | -0.173 | -0.565 | 0.096 | 1.000 | -0.199 | 0.069 | 0.120 | 0.076 |
| seats | 0.528 | 0.214 | 0.195 | 0.305 | -0.435 | 0.428 | 0.016 | -0.199 | 1.000 | 0.022 | 0.034 | 0.048 |
| seller_type | 0.096 | 0.048 | 0.000 | 0.155 | 0.040 | 0.135 | 0.134 | 0.069 | 0.022 | 1.000 | 0.211 | 0.104 |
| transmission | 0.400 | 0.036 | 0.016 | 0.513 | 0.244 | 0.455 | 0.119 | 0.120 | 0.034 | 0.211 | 1.000 | 0.153 |
| year | -0.038 | 0.133 | -0.570 | 0.162 | 0.347 | 0.107 | 0.257 | 0.076 | 0.048 | 0.104 | 0.153 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| name | year | km_driven | fuel | seller_type | transmission | owner | mileage | engine | max_power | seats | nm | rpm | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Maruti Swift Dzire VDI | 2014.0 | 145500.0 | Diesel | Individual | Manual | First Owner | 23.400000 | 1248 | 74.000000 | 5 | 190.00 | 2000.0 |
| 1 | Skoda Rapid 1.5 TDI Ambition | 2014.0 | 120000.0 | Diesel | Individual | Manual | Second Owner | 21.139999 | 1498 | 103.519997 | 5 | 250.00 | 2500.0 |
| 2 | Hyundai i20 Sportz Diesel | 2010.0 | 127000.0 | Diesel | Individual | Manual | First Owner | 23.000000 | 1396 | 90.000000 | 5 | 171.00 | 2750.0 |
| 3 | Maruti Swift VXI BSIII | 2007.0 | 120000.0 | Petrol | Individual | Manual | First Owner | 16.100000 | 1298 | 88.199997 | 5 | 171.00 | 3000.0 |
| 4 | Hyundai Xcent 1.2 VTVT E Plus | 2017.0 | 45000.0 | Petrol | Individual | Manual | First Owner | 20.139999 | 1197 | 81.860001 | 5 | 113.75 | 4000.0 |
| 5 | Maruti Wagon R LXI DUO BSIII | 2007.0 | 175000.0 | LPG | Individual | Manual | First Owner | 17.299999 | 1061 | 57.500000 | 5 | 171.00 | 3000.0 |
| 6 | Maruti 800 DX BSII | 2001.0 | 5000.0 | Petrol | Individual | Manual | Second Owner | 16.100000 | 796 | 37.000000 | 4 | 59.00 | 2500.0 |
| 7 | Toyota Etios VXD | 2011.0 | 90000.0 | Diesel | Individual | Manual | First Owner | 23.590000 | 1364 | 67.099998 | 5 | 170.00 | 2400.0 |
| 8 | Ford Figo Diesel Celebration Edition | 2013.0 | 169000.0 | Diesel | Individual | Manual | First Owner | 20.000000 | 1399 | 68.099998 | 5 | 160.00 | 2000.0 |
| 9 | Renault Duster 110PS Diesel RxL | 2014.0 | 68000.0 | Diesel | Individual | Manual | Second Owner | 19.010000 | 1461 | 108.449997 | 5 | 248.00 | 2250.0 |
| name | year | km_driven | fuel | seller_type | transmission | owner | mileage | engine | max_power | seats | nm | rpm | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5830 | Maruti Alto LXi | 2011.0 | 73000.0 | Petrol | Individual | Manual | First Owner | 19.700001 | 796 | 46.299999 | 5 | 62.000000 | 3000.0 |
| 5831 | Maruti 800 AC | 1997.0 | 120000.0 | Petrol | Individual | Manual | First Owner | 16.100000 | 796 | 37.000000 | 4 | 59.000000 | 2500.0 |
| 5832 | Maruti Alto K10 VXI Airbag | 2017.0 | 45000.0 | Petrol | Individual | Manual | First Owner | 23.950001 | 998 | 67.099998 | 5 | 90.000000 | 3500.0 |
| 5833 | Hyundai i20 Magna | 2013.0 | 25000.0 | Petrol | Individual | Manual | First Owner | 18.500000 | 1197 | 82.849998 | 5 | 113.699997 | 4000.0 |
| 5834 | Maruti Wagon R LXI Optional | 2017.0 | 80000.0 | Petrol | Individual | Manual | First Owner | 20.510000 | 998 | 67.040001 | 5 | 90.000000 | 3500.0 |
| 5835 | Hyundai Santro Xing GLS | 2008.0 | 191000.0 | Petrol | Individual | Manual | First Owner | 17.920000 | 1086 | 62.099998 | 5 | 96.099998 | 3000.0 |
| 5836 | Maruti Wagon R VXI BS IV with ABS | 2013.0 | 50000.0 | Petrol | Individual | Manual | Second Owner | 18.900000 | 998 | 67.099998 | 5 | 90.000000 | 3500.0 |
| 5837 | Hyundai i20 Magna | 2013.0 | 110000.0 | Petrol | Individual | Manual | First Owner | 18.500000 | 1197 | 82.849998 | 5 | 113.699997 | 4000.0 |
| 5838 | Hyundai Verna CRDi SX | 2007.0 | 119000.0 | Diesel | Individual | Manual | Fourth & Above Owner | 16.799999 | 1493 | 110.000000 | 5 | 171.000000 | 3000.0 |
| 5839 | Maruti Swift Dzire ZDi | 2009.0 | 120000.0 | Diesel | Individual | Manual | First Owner | 19.299999 | 1248 | 73.900002 | 5 | 190.000000 | 2000.0 |